package com.crm.model.entity.customerManager;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SingleProductCustomerContactExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SingleProductCustomerContactExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andSingleProductCustomerContactIdIsNull() {
            addCriterion("single_product_customer_contact_id is null");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdIsNotNull() {
            addCriterion("single_product_customer_contact_id is not null");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdEqualTo(String value) {
            addCriterion("single_product_customer_contact_id =", value, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdNotEqualTo(String value) {
            addCriterion("single_product_customer_contact_id <>", value, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdGreaterThan(String value) {
            addCriterion("single_product_customer_contact_id >", value, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdGreaterThanOrEqualTo(String value) {
            addCriterion("single_product_customer_contact_id >=", value, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdLessThan(String value) {
            addCriterion("single_product_customer_contact_id <", value, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdLessThanOrEqualTo(String value) {
            addCriterion("single_product_customer_contact_id <=", value, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdLike(String value) {
            addCriterion("single_product_customer_contact_id like", value, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdNotLike(String value) {
            addCriterion("single_product_customer_contact_id not like", value, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdIn(List<String> values) {
            addCriterion("single_product_customer_contact_id in", values, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdNotIn(List<String> values) {
            addCriterion("single_product_customer_contact_id not in", values, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdBetween(String value1, String value2) {
            addCriterion("single_product_customer_contact_id between", value1, value2, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerContactIdNotBetween(String value1, String value2) {
            addCriterion("single_product_customer_contact_id not between", value1, value2, "singleProductCustomerContactId");
            return (Criteria) this;
        }

        public Criteria andContactNameIsNull() {
            addCriterion("contact_name is null");
            return (Criteria) this;
        }

        public Criteria andContactNameIsNotNull() {
            addCriterion("contact_name is not null");
            return (Criteria) this;
        }

        public Criteria andContactNameEqualTo(String value) {
            addCriterion("contact_name =", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameNotEqualTo(String value) {
            addCriterion("contact_name <>", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameGreaterThan(String value) {
            addCriterion("contact_name >", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameGreaterThanOrEqualTo(String value) {
            addCriterion("contact_name >=", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameLessThan(String value) {
            addCriterion("contact_name <", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameLessThanOrEqualTo(String value) {
            addCriterion("contact_name <=", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameLike(String value) {
            addCriterion("contact_name like", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameNotLike(String value) {
            addCriterion("contact_name not like", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameIn(List<String> values) {
            addCriterion("contact_name in", values, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameNotIn(List<String> values) {
            addCriterion("contact_name not in", values, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameBetween(String value1, String value2) {
            addCriterion("contact_name between", value1, value2, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameNotBetween(String value1, String value2) {
            addCriterion("contact_name not between", value1, value2, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactPositionIsNull() {
            addCriterion("contact_position is null");
            return (Criteria) this;
        }

        public Criteria andContactPositionIsNotNull() {
            addCriterion("contact_position is not null");
            return (Criteria) this;
        }

        public Criteria andContactPositionEqualTo(String value) {
            addCriterion("contact_position =", value, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionNotEqualTo(String value) {
            addCriterion("contact_position <>", value, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionGreaterThan(String value) {
            addCriterion("contact_position >", value, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionGreaterThanOrEqualTo(String value) {
            addCriterion("contact_position >=", value, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionLessThan(String value) {
            addCriterion("contact_position <", value, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionLessThanOrEqualTo(String value) {
            addCriterion("contact_position <=", value, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionLike(String value) {
            addCriterion("contact_position like", value, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionNotLike(String value) {
            addCriterion("contact_position not like", value, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionIn(List<String> values) {
            addCriterion("contact_position in", values, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionNotIn(List<String> values) {
            addCriterion("contact_position not in", values, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionBetween(String value1, String value2) {
            addCriterion("contact_position between", value1, value2, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactPositionNotBetween(String value1, String value2) {
            addCriterion("contact_position not between", value1, value2, "contactPosition");
            return (Criteria) this;
        }

        public Criteria andContactInformationIsNull() {
            addCriterion("contact_information is null");
            return (Criteria) this;
        }

        public Criteria andContactInformationIsNotNull() {
            addCriterion("contact_information is not null");
            return (Criteria) this;
        }

        public Criteria andContactInformationEqualTo(String value) {
            addCriterion("contact_information =", value, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationNotEqualTo(String value) {
            addCriterion("contact_information <>", value, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationGreaterThan(String value) {
            addCriterion("contact_information >", value, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationGreaterThanOrEqualTo(String value) {
            addCriterion("contact_information >=", value, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationLessThan(String value) {
            addCriterion("contact_information <", value, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationLessThanOrEqualTo(String value) {
            addCriterion("contact_information <=", value, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationLike(String value) {
            addCriterion("contact_information like", value, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationNotLike(String value) {
            addCriterion("contact_information not like", value, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationIn(List<String> values) {
            addCriterion("contact_information in", values, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationNotIn(List<String> values) {
            addCriterion("contact_information not in", values, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationBetween(String value1, String value2) {
            addCriterion("contact_information between", value1, value2, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andContactInformationNotBetween(String value1, String value2) {
            addCriterion("contact_information not between", value1, value2, "contactInformation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationIsNull() {
            addCriterion("on_the_job_situation is null");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationIsNotNull() {
            addCriterion("on_the_job_situation is not null");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationEqualTo(Integer value) {
            addCriterion("on_the_job_situation =", value, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationNotEqualTo(Integer value) {
            addCriterion("on_the_job_situation <>", value, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationGreaterThan(Integer value) {
            addCriterion("on_the_job_situation >", value, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationGreaterThanOrEqualTo(Integer value) {
            addCriterion("on_the_job_situation >=", value, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationLessThan(Integer value) {
            addCriterion("on_the_job_situation <", value, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationLessThanOrEqualTo(Integer value) {
            addCriterion("on_the_job_situation <=", value, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationIn(List<Integer> values) {
            addCriterion("on_the_job_situation in", values, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationNotIn(List<Integer> values) {
            addCriterion("on_the_job_situation not in", values, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationBetween(Integer value1, Integer value2) {
            addCriterion("on_the_job_situation between", value1, value2, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andOnTheJobSituationNotBetween(Integer value1, Integer value2) {
            addCriterion("on_the_job_situation not between", value1, value2, "onTheJobSituation");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveIsNull() {
            addCriterion("is_senior_executive is null");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveIsNotNull() {
            addCriterion("is_senior_executive is not null");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveEqualTo(Integer value) {
            addCriterion("is_senior_executive =", value, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveNotEqualTo(Integer value) {
            addCriterion("is_senior_executive <>", value, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveGreaterThan(Integer value) {
            addCriterion("is_senior_executive >", value, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_senior_executive >=", value, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveLessThan(Integer value) {
            addCriterion("is_senior_executive <", value, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveLessThanOrEqualTo(Integer value) {
            addCriterion("is_senior_executive <=", value, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveIn(List<Integer> values) {
            addCriterion("is_senior_executive in", values, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveNotIn(List<Integer> values) {
            addCriterion("is_senior_executive not in", values, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveBetween(Integer value1, Integer value2) {
            addCriterion("is_senior_executive between", value1, value2, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andIsSeniorExecutiveNotBetween(Integer value1, Integer value2) {
            addCriterion("is_senior_executive not between", value1, value2, "isSeniorExecutive");
            return (Criteria) this;
        }

        public Criteria andMailBoxIsNull() {
            addCriterion("mail_box is null");
            return (Criteria) this;
        }

        public Criteria andMailBoxIsNotNull() {
            addCriterion("mail_box is not null");
            return (Criteria) this;
        }

        public Criteria andMailBoxEqualTo(String value) {
            addCriterion("mail_box =", value, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxNotEqualTo(String value) {
            addCriterion("mail_box <>", value, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxGreaterThan(String value) {
            addCriterion("mail_box >", value, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxGreaterThanOrEqualTo(String value) {
            addCriterion("mail_box >=", value, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxLessThan(String value) {
            addCriterion("mail_box <", value, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxLessThanOrEqualTo(String value) {
            addCriterion("mail_box <=", value, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxLike(String value) {
            addCriterion("mail_box like", value, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxNotLike(String value) {
            addCriterion("mail_box not like", value, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxIn(List<String> values) {
            addCriterion("mail_box in", values, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxNotIn(List<String> values) {
            addCriterion("mail_box not in", values, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxBetween(String value1, String value2) {
            addCriterion("mail_box between", value1, value2, "mailBox");
            return (Criteria) this;
        }

        public Criteria andMailBoxNotBetween(String value1, String value2) {
            addCriterion("mail_box not between", value1, value2, "mailBox");
            return (Criteria) this;
        }

        public Criteria andWeChatIsNull() {
            addCriterion("we_chat is null");
            return (Criteria) this;
        }

        public Criteria andWeChatIsNotNull() {
            addCriterion("we_chat is not null");
            return (Criteria) this;
        }

        public Criteria andWeChatEqualTo(String value) {
            addCriterion("we_chat =", value, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatNotEqualTo(String value) {
            addCriterion("we_chat <>", value, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatGreaterThan(String value) {
            addCriterion("we_chat >", value, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatGreaterThanOrEqualTo(String value) {
            addCriterion("we_chat >=", value, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatLessThan(String value) {
            addCriterion("we_chat <", value, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatLessThanOrEqualTo(String value) {
            addCriterion("we_chat <=", value, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatLike(String value) {
            addCriterion("we_chat like", value, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatNotLike(String value) {
            addCriterion("we_chat not like", value, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatIn(List<String> values) {
            addCriterion("we_chat in", values, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatNotIn(List<String> values) {
            addCriterion("we_chat not in", values, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatBetween(String value1, String value2) {
            addCriterion("we_chat between", value1, value2, "weChat");
            return (Criteria) this;
        }

        public Criteria andWeChatNotBetween(String value1, String value2) {
            addCriterion("we_chat not between", value1, value2, "weChat");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNull() {
            addCriterion("delete_status is null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNotNull() {
            addCriterion("delete_status is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusEqualTo(Short value) {
            addCriterion("delete_status =", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotEqualTo(Short value) {
            addCriterion("delete_status <>", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThan(Short value) {
            addCriterion("delete_status >", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("delete_status >=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThan(Short value) {
            addCriterion("delete_status <", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThanOrEqualTo(Short value) {
            addCriterion("delete_status <=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIn(List<Short> values) {
            addCriterion("delete_status in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotIn(List<Short> values) {
            addCriterion("delete_status not in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusBetween(Short value1, Short value2) {
            addCriterion("delete_status between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotBetween(Short value1, Short value2) {
            addCriterion("delete_status not between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNull() {
            addCriterion("create_people_id is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNotNull() {
            addCriterion("create_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdEqualTo(String value) {
            addCriterion("create_people_id =", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotEqualTo(String value) {
            addCriterion("create_people_id <>", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThan(String value) {
            addCriterion("create_people_id >", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_id >=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThan(String value) {
            addCriterion("create_people_id <", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("create_people_id <=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLike(String value) {
            addCriterion("create_people_id like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotLike(String value) {
            addCriterion("create_people_id not like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIn(List<String> values) {
            addCriterion("create_people_id in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotIn(List<String> values) {
            addCriterion("create_people_id not in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdBetween(String value1, String value2) {
            addCriterion("create_people_id between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("create_people_id not between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNull() {
            addCriterion("create_tm is null");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNotNull() {
            addCriterion("create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTmEqualTo(Date value) {
            addCriterion("create_tm =", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotEqualTo(Date value) {
            addCriterion("create_tm <>", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThan(Date value) {
            addCriterion("create_tm >", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("create_tm >=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThan(Date value) {
            addCriterion("create_tm <", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThanOrEqualTo(Date value) {
            addCriterion("create_tm <=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmIn(List<Date> values) {
            addCriterion("create_tm in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotIn(List<Date> values) {
            addCriterion("create_tm not in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmBetween(Date value1, Date value2) {
            addCriterion("create_tm between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotBetween(Date value1, Date value2) {
            addCriterion("create_tm not between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNull() {
            addCriterion("update_people_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNotNull() {
            addCriterion("update_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdEqualTo(String value) {
            addCriterion("update_people_id =", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotEqualTo(String value) {
            addCriterion("update_people_id <>", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThan(String value) {
            addCriterion("update_people_id >", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("update_people_id >=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThan(String value) {
            addCriterion("update_people_id <", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("update_people_id <=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLike(String value) {
            addCriterion("update_people_id like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotLike(String value) {
            addCriterion("update_people_id not like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIn(List<String> values) {
            addCriterion("update_people_id in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotIn(List<String> values) {
            addCriterion("update_people_id not in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdBetween(String value1, String value2) {
            addCriterion("update_people_id between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("update_people_id not between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNull() {
            addCriterion("update_tm is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNotNull() {
            addCriterion("update_tm is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmEqualTo(Date value) {
            addCriterion("update_tm =", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotEqualTo(Date value) {
            addCriterion("update_tm <>", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThan(Date value) {
            addCriterion("update_tm >", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("update_tm >=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThan(Date value) {
            addCriterion("update_tm <", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThanOrEqualTo(Date value) {
            addCriterion("update_tm <=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIn(List<Date> values) {
            addCriterion("update_tm in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotIn(List<Date> values) {
            addCriterion("update_tm not in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmBetween(Date value1, Date value2) {
            addCriterion("update_tm between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotBetween(Date value1, Date value2) {
            addCriterion("update_tm not between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdIsNull() {
            addCriterion("single_product_customer_id is null");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdIsNotNull() {
            addCriterion("single_product_customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdEqualTo(String value) {
            addCriterion("single_product_customer_id =", value, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdNotEqualTo(String value) {
            addCriterion("single_product_customer_id <>", value, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdGreaterThan(String value) {
            addCriterion("single_product_customer_id >", value, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("single_product_customer_id >=", value, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdLessThan(String value) {
            addCriterion("single_product_customer_id <", value, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("single_product_customer_id <=", value, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdLike(String value) {
            addCriterion("single_product_customer_id like", value, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdNotLike(String value) {
            addCriterion("single_product_customer_id not like", value, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdIn(List<String> values) {
            addCriterion("single_product_customer_id in", values, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdNotIn(List<String> values) {
            addCriterion("single_product_customer_id not in", values, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdBetween(String value1, String value2) {
            addCriterion("single_product_customer_id between", value1, value2, "singleProductCustomerId");
            return (Criteria) this;
        }

        public Criteria andSingleProductCustomerIdNotBetween(String value1, String value2) {
            addCriterion("single_product_customer_id not between", value1, value2, "singleProductCustomerId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}